﻿'Option Strict Off
Option Explicit On
Imports System

Imports System.Data.Common

Namespace P01_DSTableAdapters
    Partial Public Class BudgetRevPlansTableAdapter
        Inherits System.ComponentModel.Component

        Public Function GetDataByFilter(ByVal dataTable As P01_DS.BudgetRevPlansDataTable, ByVal SQLExpression As String) As Integer
            Dim OriginalCommandText As String
            OriginalCommandText = Me.CommandCollection(0).CommandText
            Try
                Me.CommandCollection(0).CommandText += SQLExpression
                Return Me.Fill(dataTable)
            Catch ex As Exception

            Finally
                Me.CommandCollection(0).CommandText = OriginalCommandText
            End Try
        End Function

    End Class

    Partial Public Class SumAct2TableAdapter
        Inherits System.ComponentModel.Component

        Public Function GetSumAct2(ByVal dataTable As P01_DS.SumAct2DataTable, ByVal SQLExpression As String) As Integer
            Dim OriginalCommandText As String
            OriginalCommandText = Me.CommandCollection(0).CommandText
            Try
                Me.CommandCollection(0).CommandText = SQLExpression
                Return Me.Fill(dataTable)
            Catch ex As Exception

            Finally
                Me.CommandCollection(0).CommandText = OriginalCommandText
            End Try
        End Function

    End Class

End Namespace